#!/usr/bin/env python3
# -*- coding:UTF-8 -*-
##########################################################################
# File Name: t.py
# Author: cx
# Created Time: Sat Oct 26 20:30:36 2024
##########################################################################
import json
import pandas as pd

def convert_json_to_excel(json_file_path, excel_file_path):
    try:
        # 读取JSON文件
        with open(json_file_path, 'r') as file:
            data = json.load(file)
        
        # 将JSON数据转换为DataFrame
        df = pd.DataFrame(data)
        
        # 将DataFrame保存为Excel文件
        df.to_excel(excel_file_path, index=False, engine='openpyxl')
        
        return f"Data successfully written to {excel_file_path}"
    except Exception as e:
        return f"An error occurred: {e}"

# JSON文件和Excel文件的路径
json_file_path = '1.json'
excel_file_path = '2.xls'

# 执行转换函数
result = convert_json_to_excel(json_file_path, excel_file_path)
print(result)
